Click Here!
home account info subscribe login search My ITKnowledge FAQ/help site map contact us


 
Brief Full
 Advanced
      Search
 Search Tips
To access the contents, click the chapter and section titles.

Oracle Performance Tuning and Optimization
(Publisher: Macmillan Computer Publishing)
Author(s): Edward Whalen
ISBN: 067230886x
Publication Date: 04/01/96

Bookmark It

Search this book:
 
Previous Table of Contents Next


Summary

This chapter described how the Oracle parallel server system operates. Using that information, you determined several ways to optimize the system, including the following:

  Partition your data. By partitioning the system so that each server primarily accesses a certain part of the data, you minimize the amount of contention and lock usage.
  Use a TM if necessary. Use a Transaction Monitor to aid in the segmentation of traffic between nodes.
  Tune PCM locks. By effectively using PCM locks, you can reduce lock contention. Use a sufficient number of locks on heavily accessed tables and reduce the number of locks on lightly used tables.
  Limit the number of rows per lock on active tables. Doing so causes more locking to occur but avoids locking rows unrelated to the data you are updating.
  Use FREELIST GROUPS. The FREELIST GROUPS storage parameter allows different instances to maintain separate free lists so that inserts occur on different parts of the data files, thus reducing contention.
  Use read-only tablespaces. If possible, take advantage of read-only tablespaces to reduce the need for PCM locks.

By understanding how the parallel server system operates, you can better tune and configure the system. You can effectively design a parallel system that provides both fault tolerance and excellent performance.


Previous Table of Contents Next


Products |  Contact Us |  About Us |  Privacy  |  Ad Info  |  Home

Use of this site is subject to certain Terms & Conditions, Copyright © 1996-2000 EarthWeb Inc.
All rights reserved. Reproduction whole or in part in any form or medium without express written permission of EarthWeb is prohibited.